microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 1

Hounding errors can occur

a) When you use multiplication, division or exponentiation in a formula

b) When you use addition and subtraction in a formula

c) Because Excel uses hidden decimal places in computation

d) When you show the results of formulas with different decimal places' than the calculated results

e) None of these

Answer: (a)

Question : 2

In Excel got functions? No? You need the insert function dialog box. How do you get it?

a) Right click a cell and then click insert

b) Click the insert menu and then click function

c) Type = in a cell

d) All of the above

Answer: (b)

Question : 3

The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the control field change.

a) ADD

b) SUM

c) TOTAL

d) LIST

e) None of these

Answer: (b)

Question : 4

In Excel two common wildcard characters that Excel recognizes are

a) * and ?

b) < and >

c) ^ and /

d) + and –

Answer: (a)

Question : 5

In Excel how many characters can be typed in a single cell?

a) 256

b) 1024

c) 32,000

d) 65,535

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 6 Online Quiz

Click to Start..
412 microsoft excel qa based computer MCQ MS excel set 6 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

SSC STENO: Time & Work Questions Solved Problems with PDF

Free Time and work Aptitude-based Practice multiple questions with solutions, Quiz series, Mock Test & Downloadable PDF for SSC Steno (Grade C & D) 2024 Exam

27-Apr-2024 by Careericons

Continue Reading »

SSC STENO 2024: Free Reading Comprehension MCQ Test PDF

Top Reading Comprehension English Section-wise multiple choice questions and answers, Full Mock Test Series & Online Quiz for SSC Steno Grade C & D 2024 Exam

26-Apr-2024 by Careericons

Continue Reading »

Free Percentage Questions Answers for SSC STENO 2024 Exam

Important Top Percentage Aptitude-based multiple choice questions and answers practice quiz series, Online Mock Test PDF for SSC Steno Grade C & D 2024 Exam

25-Apr-2024 by Careericons

Continue Reading »

Free Antonyms (English) MCQ Test for SSC STENO 2024 Exam

Top Antonyms General English Section-based multiple choice questions and answers, Free Full Test Series & Online Quiz PDF for SSC Steno Grade C & D 2024 Exam

24-Apr-2024 by Careericons

Continue Reading »